package com.hava.contentsale.dao;

import com.hava.contentsale.meta.AccountVO;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Created by yanfa on 2016/11/20.
 */
public interface AccountVODao {

    @Select("SELECT content.id,content.title,content.icon AS image,trx.price AS buyPrice,trx.time AS buyTime " +
            "FROM content " +
                "LEFT JOIN trx ON content.id=trx.contentId " +
            "WHERE (trx.personId = #{param1});")
    public List<AccountVO> findAllByUser(long user_id);
}
